VMware 17(CentOS 7)配置mysql | 您所在的位置:网站首页 › esxi 自启动无效 › VMware 17(CentOS 7)配置mysql |
借鉴自: CentOS7安装MySQL8(超级详细-无坑)_lfwh的博客-CSDN博客 启动虚拟机后: 1.进入 network-scripts: cd /etc/sysconf ig/network-scripts/ 2.配置 ifcfg-ens33: (a/o/i进入insert模式,键盘左上角esc退出insert模式,保存并退出::wq) 编辑ens33: vi ./ifcfg-ens33 修改下面内容: BOOTPROTO=static ONBOOT=yes 在末尾添加以下内容:(ip使用自己的地址,我以192.168.153.149为例) IPADDR=192.168.153.149 GATEWAY=192.168.153.2 NETMASK=255.255.255.0 DNS1=8.8.8.8 3.启动服务: service network restart 启动成功会显示: [OK] (以下操作可以进入Xshell操作:) 4.停止和禁用防火墙: systemctl stop firewalld systemctl disable firewalld 5.安装vim: yum install -y vim 6.配置vim: vim /etc/profile 显示行数: :set nu 进入编辑模式: a 注释: #mysql_home 全局使用mysql:文件位置根据自己决定 export PATH=$PATH:/opt/soft/mysql/bin 退出编辑: esc 保存并退出: :wq 加载最新配置: source/etc/profile 7.使用ftp拉取mysql压缩包:/opt/install 查看: ll /opt/install 显示:mysql安装包 mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz 查看有无mariadb文件,会与mysql冲突: rpm -qa|grep mariadb 删除mariadb文件: rpm -e --nodeps 查看到的文件名: 检查删除结果: rpm -qa|grep mariadb 8.新建/opt/soft: [root@localhost ~]# mkdir /opt/soft 跳转到install目录: [root@localhost ~]# cd /opt/install 将tar压缩文件解压到soft: [root@localhost install]# tar -Jxvf ./mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz -C /opt/soft 跳转到soft目录: [root@localhost install]# cd /opt/soft 重命名为mysql: [root@localhost soft]# mv ./mysql-8.0.31-linux-glibc2.12-x86_64 mysql 9.在mysql里面新建文件夹datas: [root@localhost soft]# cd ./mysql [root@localhost mysql]# mkdir ./datas 10. 创建用户组:groupadd mysql 创建用户:useradd -r -g mysql mysql 11.将datas放到mysql组mysql用户下: chown -R mysql:mysql /opt/soft/mysql/datas 12.更改datas的操作权限: chmod -R 750 /opt/soft/mysql/datas 13.在mysql里面创建my.cnf文件 [root@localhost mysql]# vim ./my.cnf 14.配置文件:复制下列内容 [mysql] # 默认字符集 default-character-set=utf8mb4 [client] port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 server-id = 3306 user = mysql socket = /tmp/mysql.sock # 安装目录 basedir = /opt/soft/mysql # 数据存放目录 datadir = /opt/soft/mysql/datas/mysql log-bin = /opt/soft/mysql/datas/mysql/mysql-bin innodb_data_home_dir = /opt/soft/mysql/datas/mysql innodb_log_group_home_dir = /opt/soft/mysql/datas/mysql #日志及进程数据的存放目录 log-error = /opt/soft/mysql/datas/mysql/mysql.log pid-file = /opt/soft/mysql/datas/mysql/mysql.pid # 服务端使用的字符集默认为8比特编码 character-set-server=utf8mb4 lower_case_table_names=1 autocommit =1 ##################以上要修改的######################## skip-external-locking key_buffer_size = 256M max_allowed_packet = 1M table_open_cache = 1024 sort_buffer_size = 4M net_buffer_length = 8K read_buffer_size = 4M read_rnd_buffer_size = 512K myisam_sort_buffer_size = 64M thread_cache_size = 128 #query_cache_size = 128M tmp_table_size = 128M explicit_defaults_for_timestamp = true max_connections = 500 max_connect_errors = 100 open_files_limit = 65535 binlog_format=mixed binlog_expire_logs_seconds =864000 # 创建新表时将使用的默认存储引擎 default_storage_engine = InnoDB innodb_data_file_path = ibdata1:10M:autoextend innodb_buffer_pool_size = 1024M innodb_log_file_size = 256M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 transaction-isolation=READ-COMMITTED [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer_size = 256M sort_buffer_size = 4M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout 结果如下: 15.初始化:复制下列内容 mysqld --defaults-file=/opt/soft/mysql/my.cnf --basedir=/opt/soft/mysql/ --datadir=/opt/soft/mysql/datas/mysql --user=mysql --initialize-insecure 等待初始化完毕 16.启动mysql服务: [root@localhost mysql]# mysqld_safe --defaults-file=/opt/soft/mysql/my.cnf & 查看服务是否启动成功:ps -ef | grep mysql 出现以下内容,说明配置成功: 17.无密码登录: [root@localhost mysql]# mysql -u root --skip-password 18.修改密码: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'; 19.刷新更改内容 FLUSH PRIVILEGES; 20.退出并用密码登录,看是否修改成功: exit 通过密码登录: [root@localhost mysql]# mysql -u root -p; 输入密码: Enter password: root 选择一个数据库: mysql> show databases; mysql> use mysql; 设置远程连接: mysql> update user set user.Host='%' where user.User='root'; 刷新已经进行的操作: flush privileges; 可以使用数据库软件进行远程连接。 |
CopyRight 2018-2019 实验室设备网 版权所有 |